package com.cndw.kungfu.dao;

import java.util.List;
import java.util.Map;

import com.cndw.dao.jade.annotation.DAO;
import com.cndw.dao.jade.annotation.SQL;
import com.cndw.kungfu.domain.BuffMode;
import com.cndw.kungfu.domain.SkillMode;

@DAO
public interface SkillModeDao {

	public static final String TABLE = "kfsys_skill";
		
	public static final String FIELDS = "id,vocationId,name,deputyName,skillLibId,type,icon,level,playerLevel,frontSkillId,studyBookId,asset,gold,stoneNum,costTime,description,groupType,groupNum,onlyBattleUse,targetType,passiveType,passiveValue,passiveAdd,effectValue,coolingTime,constMp,singingTime,buffRate,buffId,actionIds,playTime";
	
	
	public static final String TABLE_BUFF = "kfsys_buff";
	public static final String FIELDS_BUFF = "id,libId,signId,typeGain,name,level,icon,description,rate,lifeTime,effectValue,intervalTime,valueA,valueB";
	
	/**
	 * 获取全部技能
	 * @return
	 */
	@SQL("select "+FIELDS+" from "+TABLE+" order by id asc ")
	public List<SkillMode> selectSkillModes();
	
	
	@SQL("select "+FIELDS_BUFF+" from "+TABLE_BUFF+" order by id asc")
	public Map<Integer, BuffMode> selectBuff();	
	
	
}
